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