UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RONh38TlfL0nno7ANMsYN2glRbQhwNd+H+uX4UZDGhg=' 
WHERE 
  key_id = 'a46575d76f4aa99796026ea9d46bc91c8a05a587bd198f3470abb8e4be0ca6e9' 
  AND (
    token = 'RONh38TlfL0nno7ANMsYN2glRbQhwNd+H+uX4UZDGhg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023