UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XS7D0sOxNimFOpj4EprGI8Hpy8uzmDhAiuX/vsdMV/k='
WHERE
key_id = 'ab79f3919df66bfbb6666eaadac7f8645c16726b5168407b5592aa4ec4d67c3b'
AND (
token = 'XS7D0sOxNimFOpj4EprGI8Hpy8uzmDhAiuX/vsdMV/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)