UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crn6udqYbfnWu0VoYny4iY4Ifro1zFTXMLcp+T0D/P0='
WHERE
key_id = 'c5d80053c3d1afbaa81a48d3ad9d8486a228425b95af7e2cb23de426ac97d3dc'
AND (
token = 'crn6udqYbfnWu0VoYny4iY4Ifro1zFTXMLcp+T0D/P0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)