UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCMyb+T1IMXHHRPHBjDNL1HKj2UNNddb1/9v9FWOfXo='
WHERE
key_id = 'dfde1ad493c2ee264879faa47eed7c3063740651ef30bfdd7128c040cd0c9d4f'
AND (
token = 'ZCMyb+T1IMXHHRPHBjDNL1HKj2UNNddb1/9v9FWOfXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)