UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eYHBCIMsvp7XnF3OAfPtmmd8iU36pwq4ydIZXy0JTQw='
WHERE
key_id = '588bcf65ca74e9d05b80b11e48a45f8d901f6d1dd5cfe451f6150d674788dd9e'
AND (
token = 'eYHBCIMsvp7XnF3OAfPtmmd8iU36pwq4ydIZXy0JTQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)