UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'la6Wa3qt+lY3/JGfLTsd69U35DbKH36scmIjUK4DCnw=' 
WHERE 
  key_id = 'c51f5831a228f66e2ce4982f93cac2634621f9262b0a6674fc0fcd5b6dd72a4a' 
  AND (
    token = 'la6Wa3qt+lY3/JGfLTsd69U35DbKH36scmIjUK4DCnw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034