UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTORGk9s7BJ7FR9CBv1vDRdOqVXembvwgpRjJn1ehwY='
WHERE
key_id = '9424b50dd90865e8132e7a41ad0d39194a63b70ac24030c7d0520ec17966718c'
AND (
token = 'CTORGk9s7BJ7FR9CBv1vDRdOqVXembvwgpRjJn1ehwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)