UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2VJL07pX80X1fe8SzHpT5ehrBTqg3a9dr5zPws4Ur0='
WHERE
key_id = 'd6cef47a759ee57f0c682a6918f9de1512129f11d6ac79240b52e4e08a624599'
AND (
token = 'z2VJL07pX80X1fe8SzHpT5ehrBTqg3a9dr5zPws4Ur0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)