UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QlTI62e4YkHdNp7L48XbnGouVSZuwb7sNCJM778S3c0='
WHERE
key_id = '4ee55c4a847938d1a923dfa962a7a87fa6683deef1d5900a25c92147335e22d0'
AND (
token = 'QlTI62e4YkHdNp7L48XbnGouVSZuwb7sNCJM778S3c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)