UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3U4zMquqRdY3lPFm5ZtT6USHinwHUxwHMjxQJOW7pzs=' 
WHERE 
  key_id = 'd7f061a9a31d36782a8b8f5fac169e80e286d2b0b69c64d72a29c7ea6c057436' 
  AND (
    token = '3U4zMquqRdY3lPFm5ZtT6USHinwHUxwHMjxQJOW7pzs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037