UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEN+s+WTo60icYSHrT4aV5jQ9WhhWAMRvz7w1YT2HW0='
WHERE
key_id = 'f3111ff7caf10372d4b86c2c95f06f1ea426e85dd2dd377d103b6849e91a7c39'
AND (
token = 'XEN+s+WTo60icYSHrT4aV5jQ9WhhWAMRvz7w1YT2HW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)