UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUoVIUUP+gg4PsinMxix6ceAY/GC5hTxEYBz1rP8Too='
WHERE
key_id = 'ad7b56ce814292c5c87ef90241a6e9cdd07d05d27e7602ec4914a88f868e61a0'
AND (
token = 'CUoVIUUP+gg4PsinMxix6ceAY/GC5hTxEYBz1rP8Too='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)