UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wdGSESzJAOhKDOthBADG1pr3lgr9L4aI6YY/y2endsY='
WHERE
key_id = '5b97abde5867a1b876af403aa9486468ce07cf73eae405104f67993ebe673a8d'
AND (
token = 'wdGSESzJAOhKDOthBADG1pr3lgr9L4aI6YY/y2endsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)