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