UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nwKTpx+NvkXX5xF3cYE5MdQwfKWAgZwUeHX9h8csDhw='
WHERE
key_id = 'abf4828fdecb1666f65a2555e3e92c67b1f0d64e463c6f17a740b817ed508be7'
AND (
token = 'nwKTpx+NvkXX5xF3cYE5MdQwfKWAgZwUeHX9h8csDhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)