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