UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SOT4+6jbvgQ5UughfYa0+X1dgyUK9R9KpX/Ae4mAfyc=' 
WHERE 
  key_id = '25d321d7ae877ce98403384e7b9b3f6d953801d7b79cee0d2d75b49e2d32bbfa' 
  AND (
    token = 'SOT4+6jbvgQ5UughfYa0+X1dgyUK9R9KpX/Ae4mAfyc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030