UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FfGDAAFE8ZY90ySgavrBS8E7hgfeUxwWAKR/1QxpMAg=' 
WHERE 
  key_id = 'a1b22a7e808c07e91fd333ccca0c6176195e3a0e1b8691c9da7e3c7f44308d75' 
  AND (
    token = 'FfGDAAFE8ZY90ySgavrBS8E7hgfeUxwWAKR/1QxpMAg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044