UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wsjVd9ZfCjRLUqvoGNWOKZ/6dVAbcNqa7VMh4WURsPA=' 
WHERE 
  key_id = 'afee9b3211fe225864ec98d879d5a22c7db8841ec51672e5e735c37c8f6e434d' 
  AND (
    token = 'wsjVd9ZfCjRLUqvoGNWOKZ/6dVAbcNqa7VMh4WURsPA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046