UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpeQk8zyO4pXxogIAvRHm9xWPzxpj/j56LRNcrUYaBU='
WHERE
key_id = '07ecaf8a8562e7c3308fa2ea8d4588af02a2c60537662d156dadeb92b6c905a0'
AND (
token = 'ZpeQk8zyO4pXxogIAvRHm9xWPzxpj/j56LRNcrUYaBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)