UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Xb21FVlmuDNJdjPLuo7i9GV3eIyIQJHhI5J7LfEU0Gk=' 
WHERE 
  key_id = '7924bf8500e1df9b60664b4cdd794cf18302211aa097ed31b2f76eda55dec668' 
  AND (
    token = 'Xb21FVlmuDNJdjPLuo7i9GV3eIyIQJHhI5J7LfEU0Gk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029