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