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