UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8Tk4ijKXH4M2ywMBKOzhgZXfW7ZQqC3hLX6FjvIpuI='
WHERE
key_id = 'a275583560e34b884484633bf755ce950242066ba7c293f8cabf703285a1bb70'
AND (
token = 'B8Tk4ijKXH4M2ywMBKOzhgZXfW7ZQqC3hLX6FjvIpuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)