UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6PdKAokQY94wy4Sk/oBm7jkwGPfhI1VvrcrQWO9MRc='
WHERE
key_id = '08551d8436907cce332f6605d31e364be84008a992e6c78f6fc80baf7a7399b0'
AND (
token = 'G6PdKAokQY94wy4Sk/oBm7jkwGPfhI1VvrcrQWO9MRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)